import xlrd

def importExcelDate(sql = object, table1 = 'importTable', importExcel = 'excelLocaltion', tableDict = []):
    '''
导入excel数据
    '''
    data = xlrd.open_workbook(importExcel)
    excelTable = data.sheet_by_name(table1)
    startRowNum=3

    # dict 是无序的，无法顺序输出
    for a1 in range(startRowNum-1, excelTable.nrows):
        tableRow = excelTable.row_values(a1)
        tableRow_keys = excelTable.row_values(0)
        for b1 in range(excelTable.ncols-1):
            tableDict[tableRow_keys[b1]] = tableRow[b1]
        sql1.mySave(table = table1, datas = tableDict)
